Topics
Started by
Posts
Last post
Does anyone know what the limit is for the number of values you can have in an IN clause i.e. …
9 replies
By: jabreda
I have OLD and NEW databases. I have added few data to the NEW database. Now I need to compare with…
4 replies
Hi all, What I want is a single SQL Statement, if possible, Table bellow is a result of 3 di…
1 replies
For our main tables, when a row update is made, a trigger stores the record before and after in an …
2 replies
Hi, How can we track Level 16 errors in our SQL queries? I am creating many INSERT / UPDATE queries…
5 replies
Newbie Here.. i have 2 fields. IDNUMBER and PRINTCOUNT sample data 123456789 and 01 i am trying to…
2 replies
DBA's or Developers , I'm trying to strip data from a column in a table using an UPDATE trigger.&n…
2 replies
I need to retrieve the all the characters before the 1st numbers in a postcode string to determine …
17 replies
I'm trying to figure out a way to only return non-zero fields in a specific record. I already have…
3 replies
Hi, When I modify a stored procedure, it will overwrite the old one. Will SQL Server maintain…
1 replies
Hi, I am trying to retrieve info about the structure of a MS-SQL Server table using the OpenSchema …
1 replies
I would like to write a query that transposes the rows as columns such as below: Changes this: InvN…
1 replies
Here's my problem. I have report thats comprised of three parts. There is a table thats built …
4 replies
Hi is there any way to save a relationship diagram as a query (like generate sql for a table or SP)…
1 replies
Here's the error I get when my job fails: ... DTSRun: Executing... DTSRun OnStart: DTSStep_…
4 replies
By: rocky
Viewing 15 topics - 2,401 through 2,415 (of 4,455 total)
You must be logged in to create new topics.