Topics
Started by
Posts
Last post
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
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
Viewing 15 topics - 6,226 through 6,240 (of 10,644 total)
You must be logged in to create new topics.