Topics
Started by
Posts
Last post
Dear experts I have a table with about half a million records, each representing a patient in my co…
5 replies
i have the following stored procedure to test scope of variables alter proc updatePrereq @…
1 replies
I have written an update, if i see the execution plan of that update, it is showing the Non Cluster…
7 replies
I need to retrieve the pts from table #test1 based on the fields when mapped.. Name & Type col…
3 replies
I ran the following but only received the top 3 sales. with cte as ( select SALESMAN_ID, ORDE…
7 replies
Hello I have a query that counts number of applicants per week and displays week number and applic…
5 replies
Hi All, I have a job below, which takes the results and send to the users in email. But I have a qu…
2 replies
Hi, I am struggling to find an efficient solution to the following problem; I have a history table …
3 replies
Hello, I am working to create a phone list that will contain Last Name, First Name, and Phone Numbe…
13 replies
Hi, I need to list the current DB Backup Set up list in PIVOT STYLE. I need following way: Database…
2 replies
Hi, I have troubles with this scalar-valued UDF: I get the error: Select statements included within…
4 replies
Hi SQL Gurus, I am new to the SQL Programming and also new to this forum. I have 3 tables: CUSTOMER…
3 replies
Hi I have string as below: InvoiceTemplateId= SOURCE.InvoiceTemplateId ,Name= SOURCE.Name ,Detail…
1 replies
This is my raw data. CREATE TABLE [dbo].[rawData]( [paymentDte] [date] NULL, [zakatCode] [nvarc…
1 replies
I am emailing data using this: DECLARE @xml NVARCHAR(MAX) DECLARE @body NVARCHAR(MAX) USE R4W_001 S…
5 replies
Viewing 15 topics - 1,561 through 1,575 (of 10,647 total)
You must be logged in to create new topics.