Topics
Started by
Posts
Last post
Im geting this error when im doing my insert statement INSERT statement conflicted with COLUMN FORE…
6 replies
I'm trying to write a stored procedure to keep all records together off the ID. Everytime I t…
2 replies
Im working on a Stored Procedure to Return me 2 values. I have 5 inputs in my S.P. What im trying t…
17 replies
I need to set a trigger on a table that with each transaction will update either 1 or max 2 IDs... …
35 replies
HI All, I am trying to run a query on my CRM database. SELECT CONTACT1.COMPANY, SUM(convert(int,CON…
3 replies
Ok, for every item added to one of my tables i wanted to add or update the modifed date column. I h…
7 replies
I have a table containing a text field. The text field normally contains well in excess of 80…
3 replies
I want to subtract two different numbers to get a total and a grand total from each column. Here i…
30 replies
I am having a tough time here, the problem is: I have a table with manufacturers, applications, and…
5 replies
Is it possibel to get say any row from a table withotu havinga awhere condition. also teh tab…
10 replies
Hi ! Can anyone give me any pointers on how to count the number of instances one string appears wit…
5 replies
Hi all, I inserted 35,000 records into a table and created a locking in that table. Is there …
10 replies
why is this not working? i get an "invalid column" error.. declare @sql varchar(1000), @x v…
6 replies
Hi all, I encountered a pretty complicated dynamic SQL as below: set @sql = ' select * from openqu…
2 replies
I have a Result Table which Stores Draw Results. The prb is..I need to display the Latest 2 Draw Re…
6 replies
Viewing 15 topics - 9,601 through 9,615 (of 17,082 total)
You must be logged in to create new topics.