Topics
Started by
Posts
Last post
SCENARIO: I have a table which will potentially have millions of rows. At the moment it has 624560 …
6 replies
Hi, We are encountering an issue while querying a very large table. While working in QA, …
4 replies
I want to be able to count for each country, the number of sales reports during the last 13 weeks. …
3 replies
Hi, I would like to know if there is a way to use the switch case statement in t-sql. I cannot use …
5 replies
Hi, I was wondering if the enlightened SQL community could help me with this little problem, or my …
9 replies
SELECT Distinct(Name) FROM Upload WHERE Name Like 'ODY%' Name ----------------------------- ODYSSEY…
12 replies
I have a table that contains ID, DESC, PARENT_ID I need to end up with ID-DESC, PARENT_ID-DESC I k…
3 replies
I need to open ie from a stored procedure. The simplest way would seem to use xp_cmdshell and just …
9 replies
We've ran into a strange situation where when we script our stored procedures from our dev server a…
6 replies
I have a series of sql statements in a stored procedure that move some data around. I have th…
3 replies
Hi I want to create a function which calculates the pay period. The pay period (every 2 weeks)&nbs…
4 replies
Hello! I have this problem i need to transform a union query (SELECT …
2 replies
I have a large table (17 million rows, 76 columns, 502 bytes) that I need to copy into another…
2 replies
This is killing me. I wrote this statement below, it works great. wanted to run the sam…
2 replies
Hi, I have a populated table. I’d like to “clone” it, ie if the table is called …
7 replies
Viewing 15 topics - 13,771 through 13,785 (of 17,082 total)
You must be logged in to create new topics.