Topics
Started by
Posts
Last post
Hi All, can any one clarify the difference between NOLOCK and WITH(NOLOCK) in sql server 2008 ? whi…
21 replies
Hi, I want to find previous date from selected date. below is the sample data. DECLARE @StartDate S…
4 replies
Hello I have a cursor part in my query which needs to be performance tuned. Please suggest any chan…
16 replies
Hi SQL Experts, Looking for query which gives historical information of each job in below format. Q…
1 replies
Hi, I want to display week between two dates as below. requirement is as: suppose there are two dat…
3 replies
Hello Masters, I need to create a statement that will output a list of business sub classes base on…
24 replies
I have data laid out like this: Tablename: variations groupitem|variationname|size|color groupitem…
9 replies
I have a split string function that will take a comma delimited string and give back a table with a…
10 replies
I have two tables #main and #other . i want them to join on startdate ,kpi and tables columns and …
2 replies
I've 2 tables as follow, --> Full script and data as attachment, Scripts.zip CREATE TABLE [dbo]…
4 replies
Dear Experts, I have a requirement to generate Invoice system for 1000 customers. Please give me s…
1 replies
I have created a trigger like this below: CREATE TRIGGER TriggerName ON Table_Name AFTER INSERT AS …
7 replies
Hi, I have a group of date ranges and wanted to identify all of the date gaps within the ranges, ou…
12 replies
Is there a way to disable certian index DDL operation (create, drop and alter index) for a list of …
9 replies
Hi all, i'm a beginner and i work with sql server 2008 i have a table as this : declare @table ta…
7 replies
Viewing 15 topics - 946 through 960 (of 10,647 total)
You must be logged in to create new topics.