Topics
Started by
Posts
Last post
Hi, I hope you can help me out of this maze. I always get an error msg Incorrect syntax near ')' a…
5 replies
All, I had worked on the below requirement few days back. Create table Calc_History ( MID varchar(2…
4 replies
Hi, I am using SQL Server 2000. I have a table with the columns Current_id, Name, Previous_id and N…
1 replies
I am trying to get a record with 1 item number and the highest fifo layer number. Here is my code S…
3 replies
We have clients that are on a program for a few months, then off, then back on the program again. I…
1 replies
Hi, I am trying to do something relatively simple, but dont seem to be getting anywhere. My databas…
1 replies
How would I go about finding certain records with transposed data (typeos): Recordset Custid …
18 replies
I have a table whose data is already grouped by the first column: 1 2 7 1 2 5 1 7 3 1 4 9 2…
4 replies
We want to make a data dictionary of all our SQL statements. In this data dictionary we want to kee…
1 replies
I have a table that contains text data that is imported nightly from another system. One of the c…
9 replies
Hi there! I'm struggling to split a string.. hope somebody can help me. Here's a description of my …
48 replies
Hi, I am calling a procedure that requires two dates sets to run Eg exec my_proc '08/08/08/ , '14/…
2 replies
Hi, I have a procedure that is searching through a record set sent from an XML file and mapping and…
2 replies
Problem: I have two reference tables which join to a data table. I am using full joins as I want t…
5 replies
Need help, I think it should be a GROUP BY but am not sure SELECT d.Customer_Id, d.TestID F…
5 replies
Viewing 15 topics - 2,431 through 2,445 (of 17,082 total)
You must be logged in to create new topics.