Topics
Started by
Posts
Last post
I want to truncate data. 1. So i do ALTER TABLE table1 NOCHECK CONSTRAINT ALL 2. Then i do TRUNCATE…
1 replies
I have this stored proc and what i want to do is check is a record already exists and if it exist …
17 replies
Hello, with the first script I create and fill two tables and with second I get data that I want. B…
3 replies
Hi there, I am a total novice when it comes to T-SQL (I can do very simple select, from, where and…
14 replies
Dear all... Got task and I desperately need to come up with a solution. 1)I have two linked servers…
1 replies
I have a VB app that I'm grabbing SIDs from Syslogins/users. But, when I grab it out of SQL, and t…
8 replies
I have a query with 2 inner joins and an IN. But unfortunately i can't use the query because the ap…
6 replies
Hi, I have written a trigger for a table called test_table2. The trigger should invoke a stored pro…
8 replies
I have a stored procedure in production with an estimated cost of 6,921. When I get a copy of that …
6 replies
Hi, I have a table as so.... CustomerJob ----------- 12 2 6 33 Null…
3 replies
I am missing something in the following: F EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJ…
23 replies
Hello. I'm working on a problem where I need to find the unique combinations of suppliers that sup…
9 replies
I am not sure if i have to use CASE or IF but here is the requirement. I have a ssrs report where i…
6 replies
Hi all, wht is sql trend line formula? if anybody knows please let me know. Thanks & Regards R…
1 replies
Hi Guys, I need to select a maximum distinct date by month. I have table, then I run the following …
6 replies
Viewing 15 topics - 6,406 through 6,420 (of 12,234 total)
You must be logged in to create new topics.