Topics
Started by
Posts
Last post
Can somebody help to import xml file to a tabel using TSQL - no SSIS and dynamic SQL is allowed (c…
11 replies
Hi, I am trying to join 3 tables (Employee, EmployeeOrg, and Org) structured below. I need to retu…
4 replies
It's been years since I wrote any stored procedures - so I'm in desperate need of help. I'm hoping…
6 replies
I have a date dimension table with calendar date, year_num and month_num columns. This table is pop…
10 replies
I have a query where I am trying to exclude a hundred range of numbers after my where clause: AND p…
2 replies
I'm in the process of creating a bulk import table and a 'destination' table that will hold the dat…
6 replies
I'm trying to create a query with the output like this the query is almost done but i'm having a ha…
1 replies
Hi everyone, im busy writing a script but my try catch and subsequent rollback function is not work…
1 replies
How can i pivot table without using Pivot function as i have to pivot the string values. Pivot func…
10 replies
Hi I know there is plenty forums like this, but I can't find one that is exactly what I need... Sam…
3 replies
Hi I know there is plenty forums like this, but I can find one that is exactly my scenario. Sample …
2 replies
I'd like to collect data for a report that goes back three months using the datepart function and m…
3 replies
I have a table with and XML column similar to the example below: CREATE TABLE Test1 (ItemID int, Se…
8 replies
Hi, I am trying to run the below query but i get the error select * from table where Convert(VARC…
3 replies
I have a function that requires a varbinary(8) as input. Basically the function takes in a 32 bit h…
3 replies
Viewing 15 topics - 5,521 through 5,535 (of 12,231 total)
You must be logged in to create new topics.