Topics
Started by
Posts
Last post
In a t-sql 2012 sql, I see the following in a where statement: where ISNULL(I.Active, 0) = 1 AND IS…
4 replies
I just moved a database from SQL 2000 to SQL 2012. In the database, I have a stored procedure that …
9 replies
I'm looking for best practice in dealing with scheduled SQL Server Agent jobs in SQL Server 2012 av…
15 replies
hi, what would be the best way to do the join I have in the example file? It is getting a bit too d…
7 replies
I could use some help understanding the pitfalls of using LEFT JOINs +WHERE <field> is NULL v…
4 replies
When loading data into SQL Server through SAS DI trying to figure out the behavior regarding a data…
1 replies
It has been a while since I have written a Trigger. I need an INSERT UPDATE Trigger that will updat…
2 replies
I have a table with the following data: ID, value 1111,14.0 1111,14.0 2222,13.0 2222,13.0 3333,15.0…
6 replies
I am trying to sort my sql resultset by an alphanumeric column of a table which is of NVARCHAR data…
9 replies
I have 2 table STG is my source table and Finaltest is my target table I have 2 column in source ta…
3 replies
Hi All, I have a table as following . i am writing a query to extract data for a report. i need the…
1 replies
I should know how to do this, but it's escaping me. The actual schema I'm working against is propri…
2 replies
Here is my issue: I have got a stored procedure with a parameter on a boolean field. When the param…
5 replies
Why isn't CASE supported for flow control in T-SQL ? I have to do this ?: IF @xyz = 1 THEN EXEC d…
4 replies
Please help me re-write this query. I am sure we can get rid of multiple self joins. Data table in …
4 replies
Viewing 15 topics - 2,761 through 2,775 (of 4,984 total)
You must be logged in to create new topics.