Topics
Started by
Posts
Last post
Hey All! I have this code written up so that i can change our existing SSRS reports and SQL Agent j…
1 replies
How many rows would you consider to be too many for a single table and how would you re-arrange the…
12 replies
What methods could you use to extract specific bits of data from an XML column in a table and retur…
3 replies
I have written an IIF statement: =IIF(fields!addressline1.Value< ",", "No Details", Fields!addre…
3 replies
Any advice appreciated please. In many of our reports, some text comes through in upper case, eg a …
10 replies
Hi All, I'm lost on what I'm doing wrong. My query successfully runs with a single parameter value,…
13 replies
I am running queries through MS Query but it is bring back duplicate entries. All of the informati…
1 replies
Hi Guys/Ladies. So I have a few ways of doing it but I would like to know the BEST, FASTEST way of…
11 replies
My stored procedure has the following steps (runs every 2 hours): 1. TRUNCATE StagingTable and Data…
4 replies
Hello To cut a long story short I have some simple script that I'm sure could be coded better - it'…
3 replies
Good morning guru's of SQL. I have a task post conversion of data from a legacy system to SQL serv…
4 replies
Hi All I am creating an SSIS with variables for file name and path. The file is an excel, I have do…
14 replies
Hello I have one column in a table that shows the total number of transactions. This can be toggled…
6 replies
Hi all! ' I have a date stored in a field dato [DATETIME] How do i catch about this date is in an …
5 replies
Dear forum members, I have several hundreds of excel files that I must transfer data to SQL Server …
11 replies
Viewing 15 topics - 766 through 780 (of 5,050 total)
You must be logged in to create new topics.