Topics
Started by
Posts
Last post
I have attached a xls that shows what I need for output. This is the original code that I started w…
21 replies
please explain to me why this query EXECUTE sp_executesql N'SELECT * FROM AdventureWorks.…
6 replies
Hello I have a table that consist of product items and their unit price. Can anyone help me create …
7 replies
I have what I thought was a simple query to write...but I am perplexed. I have a table [roster] wit…
11 replies
Hi, I have a basic store procedure which performs updates on several tables, into a transaction. Bu…
10 replies
By: GSquared
Hi, I am writing a script to perform a large number of insert statements. Since there is no way to…
17 replies
By: tuseau
When executing the following SQL SELECT ASCII(''), ASCII(' '), CASE WHEN ''=SPACE(1) THEN 'TRUE' E…
4 replies
Hello I have a PRODUCTS table which contains 2 fields: old product code and new product code. I als…
5 replies
I have about 2Terabytes of data in which I have to know how may rows are there. I did a SELECT COUN…
9 replies
hi , will u plz give me query for full and diifferential with a scheduled jobs which run automatic…
9 replies
By: DAVNovak
Hi all, If I have a trigger for insert, update, and delete, is there an easy way to find out if the…
8 replies
I have a stored procedue(SP) that I am using to load data from an SSIS process. The SP is dynamic a…
1 replies
By: GSquared
Hi, I write a storeprocedure which create a pivot table. But,I can not show the resul set in my rep…
1 replies
HI I have a field called JobRole where in i found few records misspelled like DBA, Adminitrator, NI…
2 replies
I have 2 tables as follows create table ord1 (customer Char (10), division char(3), ovnd_key Ch…
12 replies
Viewing 15 topics - 10,486 through 10,500 (of 12,234 total)
You must be logged in to create new topics.