Topics
Started by
Posts
Last post
I'm hoping someone can confirm my findings here, because I understood EXCEPT to be a higher optimiz…
13 replies
Hi Guru, I have EXACTLY the same two queries one is Adhoc and one is wrapped inside a stored proced…
11 replies
I need to query data and write it out in an XML file. I am calling a sp from a .NET program and the…
4 replies
I guess the difference is the first one creates a temporary table, while the second one uses a sub-…
7 replies
I have a table that contains customer IDs, interval, and total balance at that interval. Customer …
2 replies
I've table and data as following, CREATE TABLE [dbo].[myRunnNum]( [idx] [int] IDENTITY(1,1) NOT NU…
3 replies
I apologize for most likely not describing my question in the best terms possible. Let me define ho…
9 replies
I've got some devs trying to do an export from sql 2008R2 to excel 2007 directly via TSQL. Why not …
3 replies
Hello All, I have a vendor provided stored procedure. CREATE PROCEDURE MyVendorProc @Account varch…
5 replies
I'm just curious as to how other database engineers/developers handle the usual onslaught of "how l…
16 replies
Hi there I am wanting to pull out the password_hash from sys.sql_logins such that I can use it to …
1 replies
Companies in my db have an ad quota. Some companies (not all) have a parent company The companies t…
1 replies
Hi I have a string in a field from which i need to do a select. My field contains the following ..…
2 replies
Hi Folks, I have requirement to add up an integer value in a hierarchy for each node with it's subn…
3 replies
I want to make sure I am writing clean code that is easily readable and easy to understand. What ar…
12 replies
Viewing 15 topics - 7,801 through 7,815 (of 10,635 total)
You must be logged in to create new topics.