Topics
Started by
Posts
Last post
Guys Here's the code CREATE TABLE #TestTable ( TestID INT , Region VARCHAR(50), xValue INT, xValue2…
7 replies
I have the "teach yourself SQL in 21 Days, second edition" book. Does anyone have any other recomme…
4 replies
Created temp table # xyz ( name varchar(10) Inserted multiple values in temp table like abc , rest,…
2 replies
I don't understand why I get Ambiguous column name when using a union and order by statement. I tho…
1 replies
Good day to all, Im having a hard time doing this T-SQL, can anyone help me with this one,, please.…
4 replies
hi all, i wanna to see all dependent objects of a table such as tables(with foreign key references)…
6 replies
I'm trying to create a view where I pick the ID number and highest expiration date from a table. T…
5 replies
I have two tables one (calllog) with CallID, ProjectStatus, and Classification. The second one (jo…
2 replies
Is there anyway I can spool or write the output of sql statements to a file? I would like to spool …
2 replies
Hi all, My issue this time is with cast() function and datetime. If I run following querey before a…
5 replies
hi all, I have created a dts package(first time), which contains two global variable one is input a…
1 replies
Say I have a tableA with the following columns: ID (PK, int, identity, not null) name (varchar(50),…
3 replies
I have two columns (notes and resolution), both are varchar(2000); I need to concatenate them and s…
4 replies
Example. IF EXISTS (SELECT name FROM sysobjects WHERE name = N'ReturnResponseByEventRS'…
2 replies
I have a two tables. Table 1 temp_sales is filled with all the records from my transactional databa…
4 replies
Viewing 15 topics - 1,981 through 1,995 (of 17,082 total)
You must be logged in to create new topics.