Topics
Started by
Posts
Last post
Ok so I have some dynamic sql to delete a file that is created via sql earlier on. It is to provisi…
15 replies
Hello everyone, I have data as following DECLARE @Tree TABLE ( ID INT, DateKey INT, AccountID INT,…
17 replies
THis is my code.. how do I get the variables in the cursor, set statement, to NOT update the temp t…
4 replies
Hi I want to tune this particular query as it is taking more time to execute and query cost is high…
8 replies
I have a data file listing open and close hours for the day of the week. I need to format it like M…
17 replies
Hi All, I am trying to add a where condition on an ID column(type - INT) with values coming from a …
4 replies
Hello everyone, is there a way to combine 2 stored procedures with a different set off parameters. …
15 replies
I am looking for the best way to check to see if any columns are still NULL in a record. I have a f…
5 replies
Hello! I would just like to if anyone can share a script they use to generate indexes in SQL 2005. …
5 replies
hello, i am setting up a process for the dataload, external windows service insert a record to dbo.…
5 replies
Hello, I have a table with 150 columns and about 75 rows. I would like to simply flip the table whe…
6 replies
Hi All, I have a function with multiple if ( condition) which is CPU intensive. How could I avoid …
2 replies
I have some table that need to be partitioned and archive one of the partitions. I did this in Orac…
22 replies
Hi All, My query when run I get a merge join with SORT. I want to avoid this sorting which is expen…
12 replies
I have a table has data of all months. i want to have this table data in the form as first it lists…
27 replies
Viewing 15 topics - 3,046 through 3,060 (of 4,984 total)
You must be logged in to create new topics.