Topics
Started by
Posts
Last post
Is there a way to track a truncate statement without a trace. Can there be a trigger set up or some…
4 replies
Hello its my first topic hope i'll get a solution for my troubles i have some stored procedure and …
29 replies
Other than breaking a date string into its parts and multiplying them by the appropriate number of …
11 replies
I'm almost finished with the "2012 T-SQL Fundamentals" book and while I understand both derived tab…
2 replies
Hi, I need an urgent help to get the data from previous record. I am able to calculate Cumulative d…
15 replies
Out of the two given queries, which will perform faster!!! 1. Query(1) SELECT TOP 1000 first_nam…
7 replies
Greetings, I have a database in SQL 2000 that I need to migrate to SQL 2012. I detached from the SQ…
1 replies
Anyone have an idea why the varchar data type is limited to be 1 through 8000 or MAX(2GB) but none…
5 replies
I just upgraded from SQL Server 2005 to SQL Server 2012 and had a procedure that dynamically builds…
1 replies
First off, my appologies, I am a newbie to programming and SQL. Setup: I have an SSIS package …
4 replies
I’ve experimented with several variations but now I’m ready to call in the troops - I would lik…
3 replies
It might be my density :-), but looking at examples on the net I can not find a straight forward wa…
2 replies
Here's my SQL sequence: SELECT M.BoMWOID, CAST(SUM(M.BoMEstimatedMaterialCost) AS money) AS BoM…
7 replies
Hi all, When i try to add the '+@pDatabase+'.dbo. with the tablename in line 98,99,100 AM ge…
4 replies
Hi all, Here are two very small queries in which only difference is the use of DISTINCT. Both the q…
7 replies
Viewing 15 topics - 4,816 through 4,830 (of 4,979 total)
You must be logged in to create new topics.