Topics
Started by
Posts
Last post
I am trying to create two new columns,using a case statement of the same data. For example Select …
3 replies
hi i am having trouble in select stm select "heading1" = case when (condition) then item1 …
17 replies
Hi, Can i get sample code for hierarcial query in sql ser 2008.My Scenario is as follows: I have a …
3 replies
I have data that when grouped by 4 fields, and using a having clause, displays records that don't a…
4 replies
Can someone please help me out setting up primary and foreign key relationships. Here is my issue..…
14 replies
Hello, I was given the task to try and increase performance on a query that was written years ago. …
12 replies
Hello All, Little stumped! Have a simple select stmt (SQL 2008): 1. Returns the correct result whe…
23 replies
Hello all, I've 2 separate sql servers, both 2008R2. On srv1 i created a link to linksrv in order t…
2 replies
I wonder if any of you helpful folks could suggest any alternatives to cursor for the following iss…
11 replies
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
Viewing 15 topics - 6,226 through 6,240 (of 10,647 total)
You must be logged in to create new topics.