Topics
Started by
Posts
Last post
i am getting result like item1 item2 item3 1 pen 34 1 pen null how to remove…
7 replies
Can anyone help me do this quickly in TSQL? i will post the code if i get it ready before you.:-) T…
3 replies
Dear All, Hi! I need to generate a report to show Product_Category, Product_Code, Product_Name wis…
7 replies
Hi all, CREATE TABLE TESTTABLE(VersionId int, EffectiveDate DateTime) There are no records in this …
5 replies
hi i have 1 table code item1 a pen a pencil b item3 b item4 i need to …
24 replies
Hi, I'm trying to insert rows into a remote server with identity column. Here's my sample script: S…
5 replies
Hi SQL gurus, I have a table below; FLAG1 | FLAG2 | YEAR | PERIOD | AMOUNT ---------------…
12 replies
Hi All, I am updating a table TabX on DBX of ServerX from ServerY with a stored procedure using li…
3 replies
Currently, my sql statement retrieves values for only two of possibly four values, therefore it cre…
2 replies
Hi guys I need to calculate a patient’s length of stay for every nurse station that patient has bee…
15 replies
The background for this is that I am trying to create a table that gives a list of all databases in…
10 replies
Hello Everyone I know this is simple to most, but I cannot seem to get this correct. I am having is…
8 replies
hi exp(sum(log(CASE WHEN field = 0.0 THEN 1 WHEN field IS NULL THEN 1 WHEN field= -100 THEN 1 ELSE …
2 replies
How can I write one query to limit records? Schoolname, Grade Pathfinder K South Shore 2 Whittier K…
5 replies
hi i am using 1 expression in my tsql and getting error like Arithmetic overflow error converting …
10 replies
Viewing 15 topics - 6,226 through 6,240 (of 10,635 total)
You must be logged in to create new topics.