Topics
Started by
Posts
Last post
how would i decode this in tsql select /*+ RULE */ decode(orig.orig_system,null,'ORACLE','UN…
35 replies
Any ideas how to quickly call a stored procedure to insert a record into another table for each rec…
33 replies
i've written a simple IF statement, have a look at the following code snippet... DECLARE @Result D…
1 replies
Hi all, I have a table I need to update based on certain criteria. Please see example data below; R…
5 replies
I need to restore a v2000 database to a v2005 database including all users. It's a brand new server…
1 replies
I have 10 stored procedures with the same 4 input parameters. These input parameters correspond to …
6 replies
I have the following script which is supposed to get a column of data from a table and build a comm…
6 replies
Hi! There I have a staff table which contain staff details and vacant positions as well. Now what I…
2 replies
I'm really stuck on this one. I'm basically building a social networking site for a bit of fun and …
1 replies
Hi, I'm a beginner with visual studio 05 and sql server 05. I have a store procedure who take one p…
6 replies
Hi all i have one table named member_summary fields are member_code,name,date,usagelike(opening,cr_…
4 replies
I have the following table with sample data: Row#Quarter_NameWeek ----------------------- 14Q'…
9 replies
Hi all, I have a bit of a complex issue that I'm hoping someone can help me with. In a nutshell, I …
4 replies
Hello When i run the following query: SELECT Customers.CustomerID, Customers.Forename, cleaned…
4 replies
Hi Friends How do I add an Identity column to my existing table which has got over 1 million rows? …
2 replies
Viewing 15 topics - 8,431 through 8,445 (of 12,234 total)
You must be logged in to create new topics.