Topics
Started by
Posts
Last post
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
in order to find the total no of records present in the table currently, we are using SELECT COUNT(…
5 replies
Hi, I need help with a sql query, the table looks like the below: ID product fldName fldVal 0001 AB…
1 replies
Hi! i try add a record to table. i use sql server 2008 and asp.net. i'll add record using asp.net w…
1 replies
Viewing 15 topics - 7,816 through 7,830 (of 10,647 total)
You must be logged in to create new topics.