Topics
Started by
Posts
Last post
Hi Friends, Let us assume that I have given SQLAgentOperator role to XXX Login. He has full permiss…
3 replies
Hi All, I have a column GNLBalance with negative and positive balances. I want to add these numbers…
5 replies
I have a task, here in my table I have mutiple records for single icn that means each record is dif…
1 replies
I have the following SQL statement (It's actually MYSQL but the principal is the same 😉 ) that sele…
14 replies
Hi , my query is: select distinct calendarmonthkey, calendarmonth from dim.date order by calendarmo…
1 replies
To all my SQL friends out there. While trying to construct a 1M row test harness I ran across an …
17 replies
Hi All, SQL Server 2008. I have the following problem I need to try and solve... I have a list of s…
10 replies
Hello guys, I have performance question or what is better for server I have select SELECT TOP 5 C…
2 replies
Is there a way, to import csv Files with different count of fields (all nvarchar (max)) with one St…
4 replies
Is there any way to limit the trigger, so that it only runs when the app is a .Net SqlClient Data P…
17 replies
I would like to update the complete flag of all the rows of a table except the most recent two rows…
3 replies
345 0 Test Lane 0 0, Binder, CA 00002 (MLS ID: PD1LST32) 6 N Training Road 0, Binder, CA 00006 (MLS…
12 replies
I have the following SQL statement (It's actually MYSQL but the principal is the same 😉 ) that sele…
3 replies
I'm trying to pull out the file size and backup size for each database using the msdb backup histor…
6 replies
Can someone show me how to combine these two tables and get one result set CREATE TABLE_1 ( Field1…
5 replies
Viewing 15 topics - 3,286 through 3,300 (of 10,647 total)
You must be logged in to create new topics.