Recent content by spiral123

I have an unusual situation. I have a piece of equipment that sends me its IP every 45 minutes. Once I get the transmission I have to initiate a series of calls to retrieve a certain number of records. The unit only sends me the IP and a value so I have to set it up to send then wait to receive...

found my issue, I used cast([TimeStamp] as varchar) in the headers but my [Timeheader] field was still datetime thanks though.

BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here DECLARE @PivotColumnHeaders VARCHAR(MAX) SELECT TOP 4 @PivotColumnHeaders = COALESCE( @PivotColumnHeaders + ',[' +...

I have a system where I get packets via TCPIP on port 9000(VPN) UDP on port 9000 (VPN) and TCPIP on port 6005 (not VPN)from multiple sources. Everything works well execpt every couple of nights I will stop receiving packets on port 9000 tcpip. no error occurs and i still receive udp on port 9000...

data is sent by units away from the server each unit can have 1 - 100 logs sent every 5 - 15 mins. So data can be any integer or float. And there will be alot of data. I want the most efficient way to store this data so it will be easily retrieveable and lowest overhead possible. Riverguy, I...

Hey guys I could use some help. I have a situation where i have 1- 100 fields of data coming in on a timed basis. Average is 10 at a time. Should I do this: id|field|value|timestamp which means each time I recieve data I get 1-100 records, or should I do this: id|field 1 |Field 2|...

I have a request to create a map that the users can self designate a point on the map and make it clickable. For example a map of the united states and points where every six flags is located that you can click on and up comes the phone number. The problem is i need to allow the owners of the...

I have a program that receives a binary packet then inserts the packet into a sql table. I would like to write an application the when a new record is added to the table the application retrives the binary string and parses it back into the tables as readable values. not sure which is the best...

Hello all, I need to have an email sent at a date and time contained in a table to an address contained in that table. i.e Date Email 8/8/2007 12:00:00 here@here.com would send an email on that date and time to that email. Will sql do this or will we need a third party...

no as i said the ack is being sent it appears to be more a problem with the way the UDP is being sent or maybe with the way its converted to binary

I am encountering an unusual issue. I have a send receive program for udp packets written in VB.net on a windows 2003 standard server. It receives from a custom piece of hardware and is supposed to send an acknowledgment. It sends the ack but it is not recognized on the other end. When the same...

I am encountering an unusual issue. I have a send receive program for udp packets written in VB.net on a windows 2003 standard server. It receives from a custom piece of hardware and is supposed to send an acknowledgment. It sends the ack but it is not recognized on the other end. When the same...

Im not sure how to go about it, but we have several people from different cities calling from a database. I would like to put the database in a sql database on our server so they can use the same database without splitting the numbers. That part I have under control. My issue is that my boss...

I have to replace tables from one database to another on a daily basis. The problem is if there is an error on the import the macro has a problem running when it hits the delete part. I need to check for the existence of a table before running the import feature, or just overwrite the table. any...

I have a table that has a unit number and plate number field and a province field Unit Plate Prov 1234 123AB456 Alberta 2345 145BC456 British Columbia sometimes a unit will have two plates Unit Plate Prov 1234 123AB456 Alberta 1234 125BC457 British Columbia 2345...