Topics
Started by
Posts
Last post
Hi All, I have a question on variable substitution. I have secario-1 and scenario-2 In scenario-1, …
4 replies
I have an interesting one here. I have a table of Purchase Order Item information where if there i…
10 replies
Hi all, New to SQL and I thought I had a solution in the following query, but realized that when on…
5 replies
Hi, I am LEFT joining to a lookup table by product code to find a product cost. The problem is that…
9 replies
Hi, it seems like SQL Server silently rolls back my transaction in some cases. If you try to drop a…
3 replies
I need to export my RDL files from my report server to a file(s). Here is the syntax to give me wha…
3 replies
Hi all, i have two DateTime fields in my table (from and to) which can be null.i want to write a st…
6 replies
can we make the following into single query? Select count(*) count1 FROM (SELECT DISTINCT tro.reg…
3 replies
I'm trying to set up a procedure to run at server startup. It access another db on another instance…
1 replies
Scenario: Given value1, return value2 which can have three possible values. Doing this as a scalar …
18 replies
Hey all. Thanks in advance for any help at all. I'm having problems declaring and using variables i…
6 replies
Get the all column and table name from sql query for example select emp_id, emp_name ,d.department…
7 replies
Hi All, I am trying to to execute below script: DECLARE @intFlag varchar(30) set @intFlag = 'test' …
4 replies
I have written a query which will return Rows as columns data for the past 5 years (dynamically). Q…
3 replies
Hi all, i have excel(.xlsx) file having alot of data.how i can import it to sqlserver2005's table?
16 replies
Viewing 15 topics - 1,696 through 1,710 (of 12,234 total)
You must be logged in to create new topics.