Topics
Started by
Posts
Last post
I have categories, sub-categories, sub-sub-categores and a product name. I will create Categoes tab…
12 replies
Wondering what I can do to speed up this update. It is long and I am sure there is an easier way t…
18 replies
So, I have a series of stored procedures and SSIS packages that are being upgraded from SQL Server …
2 replies
i am trying to pivot table DYNAMICALLY but couldn't get the desired result . here is the code to cr…
1 replies
OK - maybe my Google-fu is off today but I'm trying to find out if using a sequence table will prov…
12 replies
Hi, How do I add column names as Total and SubTotal for NULL values. SELECT DISTINCT --[Group] [Mon…
9 replies
SELECT [WorksheetID] ,[DateTimeCreated] ,[CreatedByUserID] ,[CreatedByImpersonatingUserID] ,[Propos…
15 replies
Assume i have 3 tables Person(personname,age) Children(childname,personname) car(carname,personname…
1 replies
Is it possible to have a constarint between two tables based on a FK relationship and a value based…
5 replies
Using sql server 2012. I am using the following code to send query results as attachment to an ema…
1 replies
On SQL 2012 (64bit) I have a CLR stored procedure that calls another, T-SQL stored procedure. The C…
5 replies
Hi all, I have a problem where I want to write a function to remove recurring characters from a str…
14 replies
I'm trying to create a cte to return a list of lots and every period between the first and last tra…
26 replies
I have a dataset that contains an EmployeeID, StartDate, EndDate, and Location. Each record tells m…
7 replies
I was reading Kenneth Fisher's[/url] and Dwain Camps[/url]' articles on unpivoting using cross appl…
7 replies
Viewing 15 topics - 4,366 through 4,380 (of 4,984 total)
You must be logged in to create new topics.