Topics
Started by
Posts
Last post
sum(Case when answera = 2 then 1 else 0 end) as answera sum(Case when answerb = 2 then 1 else 0 end…
1 replies
sum(Case when answera = 2 then 1 else 0 end) as answera sum(Case when answerb = 2 then 1 else 0 end…
1 replies
how to maintain transactions for multiple insert statements in sql server 2005 ex Create Procedure …
1 replies
Can anyone tell me why this statement works on one server (dev) but sometimes blows up on another (…
5 replies
Hi all, I designed a report layout in server and my system, the rdl in server is the old one, and t…
1 replies
Hello, I want to count rows with same id but I am not really shure about the syntax. table x rowid …
2 replies
Hi All, I want to know , as to how we can find the order of dependency in SQL Server 2005 for the o…
1 replies
error: ORDER BY items must appear in the select list if SELECT DISTINCT is specified. the above err…
1 replies
Hi, I have what should be a simple update that I stopped after 7 minutes. declare @cid int set…
2 replies
Hi, I need to write a query to update an image field with documents provided. I wrote the followi…
1 replies
I need to change the values in a field, leaving the last 4 characters only. Would like to change t…
5 replies
I made an index on a table named stock_items that has a field named batch_file_id , this is the new…
9 replies
I have to write a function to return a due date. The way the system works is if I have a due time …
13 replies
Hello all, I have been in the process of transferring a database from Access 2007 to SQL Server 20…
26 replies
Hi All, What is wrong with this statement. Even when CHARINDEX is zero it goes thru the 2nd cas…
25 replies
Viewing 15 topics - 7,156 through 7,170 (of 12,234 total)
You must be logged in to create new topics.