Topics
Started by
Posts
Last post
Hi, Does it matter if I use simple case, i.e. SELECT CASE STATUS WHEN 'A' THEN 1 WHEN 'B' THEN 2 E…
4 replies
I have a field that can contain different types of info, I want to match a 10-digit number. How can…
2 replies
Hi, Please let me know difference between temp table, table variable, derived table and CTE. Thanks…
3 replies
I receive semi colon delimited txt file and the column placements/position are always same. Current…
4 replies
I am trying to find my SQL Server's FQDN using T-SQL and then have it inserted into all of the fiel…
10 replies
I'd like to have the min and max date for each dept, but so far I've been stumped when the person g…
3 replies
I have two tables. TableA and TableB and both contains 3 columns. The amount which is entered in t…
1 replies
We have a fairly standard table, A Customer table. PK is Customer_ID and End_Effective_Date. One o…
6 replies
Is there a way to replace NULL to a datetime column instead of 1900-01-01 00:00:00.000 for NULL dat…
10 replies
I have "running total" that I solved using..... cursors. Anyway, very slow, about 5 minutes. I don'…
3 replies
I am working on implementing a business logic, I need help figuring out the logic Logic: Each cust…
19 replies
Gotta question about a possible plan guide scenario. I have a sproc that executes a sequence of sta…
3 replies
Hello, I have an development database which I need to refill with production data on a regular basi…
4 replies
I have 3 tables with following columns Table A ID int Value varchar(max) Example Data 1 3,620.00 2 …
14 replies
I've created a view in SQL 2008 with the sql code below. The problem column is i.QTY I need the per…
6 replies
Viewing 15 topics - 2,116 through 2,130 (of 12,230 total)
You must be logged in to create new topics.