Viewing 15 posts - 931 through 945 (of 2,894 total)
...
Apologies for my lack of information i am new to SQL and to this forum.
The following will get you started receiving relevant and fast responses on this forum:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 14, 2012 at 5:31 am
...if I change the Recovery Model to Bulk-Logged, will that prevent the log files growing substantially during the process, or would I be better off if I script an export...
November 14, 2012 at 3:54 am
Google the following:
Concatenate FOR XML PATH
November 14, 2012 at 3:51 am
Evil Kraig F (10/30/2012)
...CREATE TABLE #Tmp CREATE INDEX idx1 INSERT INTO #tmp SELECT
runs about 1.5x - 2x faster (depending on the index) as
SELECT INTO #tmp CREATE INDEX idx1
...
Could you...
November 14, 2012 at 2:55 am
BTW. Formatting your query nice, improves its readability and therefore its maintainability:
SELECT vcEmployeeUniqueID
,vcLastName
...
November 13, 2012 at 10:23 am
You are almost there!
just use MAX instead of COUNT 🙂
also you don't need to sub-query select of all columns from #X:
...
FROM #X1 p
PIVOT ...
will do just fine!
November 13, 2012 at 10:20 am
Looks like homework to me.
Have you tried using PIVOT. Where are you so far?
We can help you to learn and resolve issues instead of just providing straight solutions,...
November 13, 2012 at 10:12 am
No need in duplicating your posts!
http://www.sqlservercentral.com/Forums/Topic1384158-392-1.aspx
November 13, 2012 at 10:08 am
edward_hall76 (11/13/2012)
November 13, 2012 at 9:22 am
edward_hall76 (11/13/2012)
November 13, 2012 at 8:08 am
To pass values as a comma separated string, you need to concatenate them into one comma separated string and pass it.
To use it in you procedure, you can use "IN"...
November 13, 2012 at 7:43 am
2Tall (11/13/2012)
I have a query which in brief has the...
November 13, 2012 at 6:58 am
ben.brugman (11/13/2012)
How to save the results from "SET STATISTICS TIME ON" in table format?Ben Brugman
In exactly same way as result of PRINT - it is impossible in T-SQL as it's...
November 13, 2012 at 6:50 am
That is what could easily win "Query From Hell" competition...
It's "War and Peace" of the queries!
Does it run at all (even without grouping)?
Before trying to help or resolve any problem...
November 12, 2012 at 3:19 am
Viewing 15 posts - 931 through 945 (of 2,894 total)