Topics
Started by
Posts
Last post
I have three tables as follows TableA ------ Col1 col2 col3 1 C01 1 2 C02 2 3 C03 1…
5 replies
Hi All, I have the below scenario. create table cur_range ( currency char(3), statement_date dateti…
6 replies
I found the script sqlskills site, this is good script for clearing the single user plan as well as…
13 replies
I get this error when creating a table using 'AS CASE WHEN': Msg 0, Level 11, State 0, Line 0 A sev…
4 replies
Hello All Good Evening, Could you please help me with this query, how can i write this query withou…
5 replies
Hi all... Can this be done without a cursor: create table #Order (Order_id int, qty int, ship_qty…
8 replies
I get following results from table1: Sys TeamID ----- ---------- 100 Team-1 …
1 replies
Hi all, Just wonder if I can get some help with a script that would allow me to restore 20 + .bak f…
3 replies
I have a function dbo.fn_ConvertToNumeric(@a) and am using it in an update statement for a table ha…
7 replies
I'm writing a stored procedure with a fairly complex SQL statement that I've converted to Dynamic S…
7 replies
Hi, Result in separate column? I have data like one row (ab-xyz, bc-xyz, cd- xyz) I want output, ho…
2 replies
Hi I have a table that looks like this; CustomerID Amount Date RunninTotal 1 …
5 replies
Hello Everyone I hope that your day is going a bit better than mine 🙂 I am working on some really o…
2 replies
Hi all, I've been given a rather meaty CASE statement which is of the form: UPDATE Table SET x = CA…
8 replies
I have a field in a table where the data varies in length. For some records, the length of the fiel…
11 replies
Viewing 15 topics - 2,431 through 2,445 (of 10,647 total)
You must be logged in to create new topics.